Module 1 of Path: Become a Database Professional with SQL
Database Design Fundamentals for Software Engineers
Module Overview
Databases are universal - they underlie the technology you use every day. They're a crucial component of everything from telecommunications systems, banking systems, and video games to just about any other software system that maintains some amount of persistent data. In this module, you'll learn about the fundamental concepts of databases, why and when they're used, what relational databases are, and entity-relationship diagrams. You will also be exposed to techniques like normalization that help to increase the efficiency of databases. You'll wrap up with a look at the basics of Structured Query Language (SQL). After completing this module, you will be able to move on to more advanced courses involving database systems and SQL.
Module Objectives
Learn the database fundamentals for Software Engineers.
Learn about entity relationship data model.
Learn about data modelling and normalization.
73 Lessons
34 Quizzes
84 Playgrounds
56 Code Snippets
188 Illustrations
Contents (Module 1)
Module 2Contents (Module 1)
Module 22. Fundamental Concepts
3. Data Modeling
4. Entity-Relationship Data Model
Intro to Entity-Relationship Model
Entities, Entity Sets and Entity Types
Attributes
Keys
Relationships, Relationship Sets and Relationship Types
Degrees of Relationship Types
Binary Relationship Type Constraints
Attributes of Relationship Types
Weak Entity Types
Exercise 1
Solution to Exercise 1
Exercise 2
Solution to Exercise 2
5. The Relational Data Model
6. Functional Dependencies
7. Normalization
8. Structured Query Language
Structured Query Language (SQL)
SQL Data Types and Operators
SQL Constraints
CREATE, DROP, and USE Databases
CREATE, DROP, and INSERT Table
The SELECT Clause
The WHERE Clause
The AND & OR Clauses
Aggregate Functions in SQL
ORDER BY & GROUP BY
The HAVING Clause
Alias Syntax
SQL Joins
INNER JOIN
LEFT JOIN
RIGHT JOIN
Exercise 1
Solution to Exercise 1
Exercise 2
Solution to Exercise 2
Exercise 3
Solution to Exercise 3
Exercise 4
Solution to Exercise 4
9. Conclusion
73 Lessons
34 Quizzes
84 Playgrounds
56 Code Snippets
188 Illustrations
